Patterson isn’t just a place to work, it’s a partner that cares about your success.
One of the distinguishing marks of our company is the talented people who embrace the people-first, always advancing, and results-driven culture. Professional growth abounds in this motivating environment. We value the diverse talents and experiences our employees bring to Patterson and believe that they build a stronger and successful organization.
The BI Developer will be responsible for designing, developing, and maintaining cloud base business intelligence solutions utilizing Azure. The BI Developer works closely with business stakeholders, business analysts, and developers to understand requirements and develop and support BI solutions. This role will utilize Microsoft BI tools and technologies to deliver accurate and insightful data visualizations, reports, and dashboards.
Responsibilities:
- Design and develop end-to-end business intelligence solutions using Azure technologies, including but not limited to: Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, and Azure Analysis Services.
- Design and develop data models, data warehouses, and ETL processes.
- Collaborate with business analysts and development teams
- Create and maintain SQL queries, stored procedures, and functions to extract, transform, and load data from various sources.
- Design and develop interactive dashboards using Microsoft Power BI utilizing drill down data exploration for deep insights.
- Optimize and tune SQL queries, data models, and ETL processes for performance and efficiency.
- Implement data security measures and ensure compliance with data governance policies.
- Keep up-to-date with the latest Microsoft BI technologies and best practices.
Required Qualifications
- Bachelor’s degree in computer science, or Information Systems
- Minimum of three (3) years experience as a BI Developer or similar role, utilizing Microsoft BI technologies
- Strong knowledge of Microsoft SQL Server, SSIS, SSAS, and Power BI.
- Proficient in SQL querying and data modeling
- Experience in developing data visualizations.
- Understanding of data warehousing principles and ETL processes.
- Ability to work independently and as part of a team, managing multiple priorities and deadlines.
- Excellent analytical and problem-solving skills.
- Strong communication and collaboration abilities.
Preferred Qualifications
- Experience with Microsoft Azure services such as Azure Data Factory, Azure Analysis Services, or Azure Synapse Analytics.
- Knowledge of data visualization best practices and user experience design.
- Experience with agile development methodologies.
The potential compensation range for this role is below. The final offer amount would be based on various factors such as candidate location (geographical labor market), experience, and skills. $85,000.00 – $100,000.00
What’s In It For You:
We provide competitive benefits, unique incentive programs and rewards for our eligible employees:
- Full Medical, Dental, and Vision benefits and an integrated Wellness Program.
- 401(k) Match Retirement Savings Plan.
- Employee Stock Purchase Plan (ESPP).
- Paid Time Off (PTO).
- Holiday Pay & Floating Holidays.
- Volunteer Time Off (VTO).
- Educational Assistance Program (Tuition Reimbursement).
- Full Paid Parental and Adoption Leave.
- LifeWorks (Employee Assistance Program).
- Patterson Perks Program.
EEO Statement
As a people-first company, Patterson promotes a culture that embodies and celebrates diversity and inclusivity. We believe our employees’ unique experiences and differences is what strengthens us and drives our success. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status.
We are Patterson. We welcome you.
Azure Data Factory data-modeling Agile SQL data-warehouse ETL azure-data-lake azure-analysis-services Power BI