Data and Analytics Engineer

jobmobile in facebook   jobmobile in twitter
email Email alert


Job Title:
Data and Analytics Engineer
Robert W. Baird
Architecture and Design
Job Description:
Are you addicted to making sense of business data? Are you naturally curious and passionate? Are you driven by enabling mission-critical business processes and data-driven decisions? Are you pragmatic and inspired by meeting people where they are? Want to contribute to a growing financial services company who values IT as a partner to the business? Keep reading... As we continue to grow and add top talent to the Baird family of technical associates, we are looking for a Data and Analytics Engineer for our downtown Milwaukee headquarters. This is a key role on our IT Data Team requiring a broad range of skills and the ability to step in to different roles depending on the size and scope of the business need. The self-motivated candidate will have proven experience implementing successful data solutions on key projects in a collaborative environment. Success will come from being able to prioritize, deliver value incrementally, problem solve, and manage changing priorities. You will work closely with our business partners and interface with both technical and non-technical colleagues. As a 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 the business and technical 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 in order to collaborate effectively with the business users, business analysts, and data owners. Develop and validate source to target mappings and transformation logic required to support business needs. Understand the importance of capturing data lineage. 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. 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) Leverage existing tools to create data visualizations and mentor the business to be self-sufficient Engage in continuous learning of Baird’s business functional areas to more effectively partner with our business SME’s 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. Help delivery teams develop solutions that enable businesses to capitalize on business insights and drive toward gaining a competitive advantage Lead and Coach: Provide awareness to IT and business team members of data management practices. Aid in and promote data custodianship from an IT perspective. (standards, processes, metadata) Contribute to the direction of data development, platforms, versions, and toolsets 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 Baird’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 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: Alteryx, Microsoft tools (SQL Server Management Studio, SSRS, SSAS, SSIS, Power Pivot, Power Query, PowerBI) 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 More about Baird: Baird is an employee owned, international wealth management, capital markets, private equity and asset management firm with more than 100 offices in the United States, Europe and Asia. Established in 1919, Baird has over $208 billion in client assets and more than 3,600 associates serving the needs of individual, corporate, institutional and municipal clients. Baird has built an environment of trust, respect and teamwork, where associates are our greatest asset. As stated in our Associate Promise, we are passionate about how we achieve great outcomes together for our clients, communities and each other. Committed to being a great place to work, Baird ranked No. 16 on the Fortune Magazine’s 100 Best Companies to Work For®, our sixteenth consecutive year on the list. #LI-KC1
Data and Analytics Engineer - Find thousand of job offers Data and Analytics Engineer in United States ,Find all offers posted by this company Robert W. Baird.
This job is published in categoryArchitecture and Design, refers to the provinceMilwaukee