Business Intelligence Engineer (no C2C or subcontractors)

Business Intelligence Engineer

PowerBI Architect

Data Warehouse Architect

(Sr.) Data & Analytics Engineer

Contract to Hire - W2 only. No C2C or subcontractors should apply

Summary: This person will be a Power BI Expert & Architect will be responsible for designing, developing, and implementing Power BI solutions to meet the business needs. This role requires a deep understanding of data visualization, data modeling, semantic modeling, and business intelligence best practices. The ideal candidate will have a strong technical background, excellent problem-solving skills, and the ability to work collaboratively with cross-functional teams.

• Contract duration 6 Month then expected conversion to an employee.
• Target Salary: $130k/yr (flexible) + 25% annual Bonus + excellent benefits and profit sharing. Payout of bonuses every year even during COVID
• Location We are currently working in a hybrid setting, working 3days in the office and 2 days remotely. Candidates must live in the Greater Milwaukee area
• Temporary hourly rate: $75-$80/hr

Position Responsibilities

Business Intelligence:

• Create and maintain data models, including semantic models, ensuring data integrity and accuracy.
• Develop and manage data flows to optimize data processing and integration.
• Design and develop Power BI reports and dashboards to provide actionable insights.
• Optimize Power BI solutions for performance and scalability.
• Implement best practices for data visualization, report design, and semantic modeling.
• Conduct training sessions and provide support to end-users.
• Stay updated with the latest Power BI features and industry trends.

Data Architecture:

• Specialize in data modeling, both 3NF and dimensional, with experience in conceptual, logical, physical, and industry data modeling. Strong knowledge and experience with data architecture methodologies.
• Apply the appropriate level of modeling theory, pattern recognition, and abstractions to architect and design a pragmatic solution that functionally meets the business and technical requirements.
• Develop and validate source to target mappings and transformation logic required to support business needs. Understand the importance of capturing data lineage.
• Architect, implement, and verify end-to-end data solutions.
• Develop test plans needed to ensure a quality deliverable. Participate in validation testing, coordinate user acceptance testing, and training to ensure the final implementation enables the user to solve their business problem.

General Data Management:

• Play a critical role in architecting our data and analytics solution landscape.
• Demonstrate competence, experience, knowledge, understanding, and advocacy of data management concepts, data warehousing, BI, and analytics.
• Demonstrate ability to perform appropriate level of strategic thinking by viewing initiatives both within the immediate project context as well as the overall architectural vision.
• Participate and/or lead in data architectural design and strategy discussions.

Data Delivery:

• Work with the business users to conduct data discovery engagements and can quickly identify, and prototype, a solution that brings together multiple data sources into one coherent concept and understanding (data blending).
• Leverage existing tools to create data visualizations and mentor the business to be self-sufficient.

Collaborate Build Relationships:

• Identify and communicate project risks and impediments and proactively work with other members of the Analytics team to complete high-value deliverables as identified by business partners and team leadership.
• Partner with Analytics team members to translate business and functional requirements into technical designs.
• Strive to understand the data consumption needs of the business community, as well as the problems faced by business users involving the access and use of data.
• Help Analytics teams develop solutions that enable businesses to capitalize on business insights and drive toward gaining a competitive advantage.

Technical Profile:

• Minimum of 5-7 years of experience in Data Solution delivery in a complex environment working collaboratively in a team setting.
• Proficient in Data Solution tools and concepts such as:
• Business Intelligence tools: Microsoft tools (Power BI, SQL Server Management Studio, SSRS, SSAS, Power Pivot, Power Query), Alteryx.
• Database: SQL Server or Snowflake.
• Data Management and Quality: data mapping, data profiling, metadata repository, relational data modeling, master data management.
• Data Modeling: ER/Studio Data Architect, 3NF and dimensional modeling.
• Data Integration concepts and strategies: EII, ETL, EL-T, EAI, Fivetran.
• Data Transformation tools: dbt, SSIS

Preferred Qualifications:

• Experience with BI tools in addition to PowerBI (e.g., Tableau, Qlik).
• Knowledge of cloud platforms (e.g., Snowflake, Azure, AWS).
• Certification in Power BI

Benefits to joining this team:

• Information technology is a core part of this firm's business strategy and plays a critical role in the growth and transformation of the firm.
• Fortune 100 and Computer World Best Company to Work For with collaborative culture that values diverse backgrounds and perspectives while emphasizing teamwork and a strong sense of partnership.
• Rich developer community with lunch & learns on best practices. Focus on software artisanship.
• A DevOps culture. We use automated deployment and are constantly looking to improve in the DevOps space. Our DBAs/App Admins are part of our collaboration.
• Agile/lean practices with diversity of projects
• Ability to use a breadth of technology to positively impact the technology experience for all Baird associates.
• Great team atmosphere with long-term growth opportunity.
• Support and flexibility to grow and be your best at work, at home, and in the community.