Codeworks is an IT Services firm headquartered in SE Wisconsin, known for our strong commitment to quality and for our direct client relationships. Who We’re Looking For: A Power BI Expert & Architect 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. This is a Contract to Hire position based out of Milwaukee, WI on a hybrid weekly schedule. Responsibilities: 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. 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. 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. 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. 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. Qualifications: Minimum of 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, Snowflake. Data Query tools: SQL, T-SQL. 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 Warehousing concepts: Inmon, Kimball, Data Lake. Data Integration concepts and strategies: EII, ETL, EL-T, EAI, Fivetran. Data Transformation tools: dbt, SSIS Preferred Qualifications: Master's degree in a related field. Experience With Other BI Tools (e.g., Tableau, Qlik). Knowledge of cloud platforms (e.g., Snowflake, Azure, AWS). Certification in Power BI About Codeworks: Codeworks has over 25 years of experience serving Fortune 1000 companies in Wisconsin as well as our client's national locations. Our recruiting team excels at evaluating, advising, and connecting IT professionals with new opportunities that will satisfy their expectations regarding income and opportunity for growth. At Codeworks, we're committed to diversity, equity, and inclusion in our workforce and beyond. We believe in equal opportunities and value the unique perspectives that every individual brings to our team. Join us in creating an inclusive, innovative, and collaborative workplace where your talents can thrive. Codeworks is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Codeworks, LLC discloses that the anticipated hourly pay range for this position is between $80 and $100. This range is subject to change based on job-related factors, including client requirements where applicable. All full time Codeworks employees are eligible to enroll in the company’s medical, dental, vision, and life insurance plans. Additionally, employees can participate in Codeworks’ 401(k) retirement plan.