Job type full-time
Full job description
Microsoft bi stack developer / analyst
At megafood, our mission is to nourish a world in nutritional crisis by producing the highest quality supplements made with farm fresh whole foodsMegafood is a proud certified b corporation, meeting rigorous standards of social and environmental performance and a driver of change in the creation of meaningful jobs, the improvement of lives, and the application of best business practicesWe are always looking for people who are passionate about our mission to join our growing team!
This is a special opportunity for a person energized by the rewards and challenges of bringing business value to life - through the application of analytical, interpersonal, and technical bi resourcesThe ideal candidate will have strong business knowledge exemplified by the ability to translate business needs into technical bi tools.
Ability to execute all phases of bi tool development: needs analysis, solution conceptualization, prototype development, and on through to user acceptanceIn-process adjustments gathered from user feedback is criticalThis role offers the satisfying opportunity to exercise interpersonal, analytical, technical, and creative skills.
Essential general functions and responsibilities
Gather and translate business requirements and build-out insightful bi solutions, following established departmental design patterns.
Research existing system databases to identify valuable data, and crystalize the business logic required to translate this into useful bi information.
Adherence to established design standards while effectively managing internal customers’ expectations“ choosing the right tool for the job”
Comfortable working on a wide range of projects: bi tool development, system integrations, and backend system analyses.
Research new data sets and establish new integrations to generate both incremental, and transformative business value.
Perform data validations and implement automated data quality checks to perfect data reliability and consistency.
Ability to generate and maintain code documentation using clear communication practices.
Active learner, and curiousWilling to learn fundamentals of functional business areas.
Specific, required technical expertise / skills
Dax development expertise, as expressed in:
Power bi dashboard development
Full dashboard development from data ingestion, data modelling creation of metrics, and graphical storytelling
Dashboard deployments into powerbi.com
Excel power pivot data models (prototypes for full azure tabular cubes)
Full powerpivot development from data ingestion, data modelling and creation of metrics
Visual studio, t-sql, sql server management studio, sql server admin, as expressed in:
Ssis (sql server integration services) - etl package development & deployment
Ssrs (sql server reporting services) - parameterized reports
Sql server agent -> job creation, scheduling & failure analysis
Vb.net or c#
Additional technical skills
(possessing these would enhance your candidacy, or represent areas in which you would like to grow your skill set)
Dax, as expressed in:
Ssas tabular models (deployed to azure)
System / site administration
System admin activities
Data warehouse design
Code management solutions
Azure dev ops server
Azure data factory
Azure machine learning / azure synapse
Azure sql database
What we offer you: we aspire to nurture a culture of inclusion that enables and encourages all of our employees to thrive.
Here are a few ways we do that:
Eligibility for our benefits on your first day of employment
Paid time off to pursue your passion through our volunteer program
Annual wellness reimbursement, fitness challenges, free chair massages, and lots more to keep you healthy!
Generous time off programs including vacation and personal time and paid parental leave
Opportunity to work with passionate people, who care about our mission and each other!
Megafood is committed to cultivating and preserving a culture of diversity, inclusion and belongingThe collective sum our individual differences, knowledge, life experiences, and unique talents, represents a significant part of our culture and is the foundation for our accomplishments and impact.
We are proud to be an equal opportunity employerWe do not discriminate on the basis of race, color, religion, citizenship, national origin, sex (including pregnancy), sexual orientation, gender identity or expression, age, physical or mental disability, veteran status, marital status, genetic information, or any other characteristic protected by state, federal or local lawWe strive to create a supportive community where we all are comfortable and confident to be authentic, open and curious.
If you need a reasonable accommodation because of disability for any part of the employment process, please send an email to firstname.lastname@example.org or call 603-216-6473 and let us know the nature of your request and your contact information.