Data Architect / Data and Analytics Engineer #JP – BD02
Location: MILWAUKEE or MADISON, WI (remote during COVID) Duration: 6 months Contract to Hire or PERMANENT
What we look for:
Minimum of 5 - 7 years of experience in Data Solution delivery in a complex environment working collaboratively in a team setting
Proficient in some of the following tools:
Business Intelligence tools: Microsoft tools (SQL Server Management Studio, SSRS, SSAS, SSIS, Power Pivot, Power Query, PowerBI), Alteryx
Database: SQL Server
Data Query tools: SQL, T-SQL
Data Modeling: ER/Studio Data Architect, 3NF and dimensional modeling
Data Integration tools: SSIS
Conversant in the following concepts:
Data Warehousing concepts: Inmon, Kimball, Data Lake
Data Integration concepts and strategies: EII, ETL, EL-T, SOA, and EAI
Reference Data Management
Data Management and Quality: data mapping, data profiling, metadata repository, relational data modeling, master data management
As a "Data Architect" or "Data and Analytics Engineer," you will: General Data Management
Play a contributing role in building our data and analytics practice.
Demonstrate competence, experience, knowledge, and understanding of data management concepts, data warehousing, data integration, BI, and analytics.
Demonstrate ability to recognize the immediate project context as well as the overall vision.
Demonstrate ability to perform abstract thinking by being able to identify higher level patterns in multiple detailed scenarios.
Data Engineering
Skilled 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 design a pragmatic solution that functionally meets requirements.
Partner with internal business units to define information requirements and translate them into appropriate data solutions
Performs data analysis and data profiling to gain a solid understanding of the business data to collaborate effectively with the business users, business analysts, and data owners.
Develop and validate source to target mappings and transformation logic.
Understand the importance of capturing data lineage.
Take appropriate steps to ensure sensitive data is protected and secure.
Data Delivery
Work with the business users to conduct data discovery engagements.
Design and prototype a solution that brings together multiple data sources into one coherent concept and understanding. (data blending)
Engage in continuous learning of our business functional areas to more effectively partner with our business SMEs
Collaborate – build relationships!
Identify and communicate project risks and impediments and proactively work with other members of the team to complete high-value deliverables as identified by business partners and team leadership
Partner with project team members to translate business and functional requirements into technical designs
Partner with the business stakeholders to develop sound information usage, access, management, and understanding.
Lead and Coach!
Contribute to the direction of data development, platforms, versions, and toolsets
Provide awareness to IT and business team members of data management practices.
Knows when to give and take and can clearly communicate the “why” of a specific decision or approach.
Develop best practices and communicate to teams with a focus on empowering others to implement quality value-add solutions.
Seek out and apply new technologies and skills in daily work through conferences, online training, reading, participation in organizations and user groups, etc.
What makes this opportunity great:
Information technology is a core part of the company’s business strategy and plays a critical role in the growth and transformation of the firm
Ability to build solid data integration solutions that feed mission-critical business processes and decisions
Ability to work a variety of teams and leaders, proving your ability to be flexible and high adaptable
Unique culture that values diverse backgrounds and perspectives while emphasizing teamwork and a strong sense of partnership
Benefits
Flexible work arrangements available
Profit sharing
Pretax, Roth and voluntary 401(k) after-tax contributions and above-average retirement benefit with the combination of a 401(k) firm match and firm profit-sharing
High bonus - believed to be in the 20-25% bonus range.
Health and Dental insurance
Free basic term life and disability insurance
FSA and HSA
Tuition and designation/certification reimbursement available for all regular associates
Nine paid holidays and 18 Paid Time Off days (pro-rated for the first year)
Free identity, financial and privacy-protection coverage for associates and their family members
Rate discount upon refinancing federal and/or private student loans.