Data Architect - Milwaukee, United States - AE

    AE
    AE Milwaukee, United States

    3 weeks ago

    Default job background
    Description

    AE Business Solutions is looking for a Data Architect for a hybrid, contract to hire position with a client located in Milwaukee, WI. The Architect will possess excellent leadership capabilities and lead architectural design and strategy discussions to support the mission and growth of the Data and Analytics organization.

    **Local candidates preferred**

    **Candidates must be within a commutable distance to Milwaukee, WI or willing to move at their own expense and be onsite Day 1**

    What you will be doing:

    • Help Data and Analytics teams develop solutions that enable businesses to capitalize on business insights and drive toward gaining a competitive advantage.
    • Mentor Data and Analytics team members while helping them to create solid data solutions.
    • Create high-level architectures of new data environments (e.g. architecture diagrams, city maps, conceptual data models, warehouse architectures and designs, business engagement models, ELT and consumption strategies and patterns, etc.).
    • Provide technical leadership, mentoring and awareness to IT and business team members.
    • Recognize when Solution Architects need to be consulted, informed, or engaged.
    • Develop best practices and communicate to teams with a focus on empowering others to implement quality value-add solutions.

    What you bring to the table:

    • Minimum of years of experience in Data and Analytics Solution delivery in a complex environment working collaboratively in a team setting.

    Proficient in Data Solution tools and concepts such as:

    • Business Intelligence/Analytics tools: Alteryx, Python Microsoft tools (SQL Server Management Studio, SSRS, SSAS, SSIS, Power Pivot, Power Query, Power BI).
    • Database: SQL Server, Azure SQL Database, ADLS, Snowflake.
    • Data Query tools: SQL, T-SQL, Azure Data Studio.
    • Diagramming tools: ER/Studio Data Architect, Miro, Visio, PowerPoint.
    • Data Integration tools: SSIS, Azure Data Factory, DBT, FiveTran.
    • Data Warehousing concepts: Inmon, Kimball, Data Lake, Data Lakehouse, Modern Data Architecture
    • Data Integration concepts and strategies: EII, ETL, ELT, SOA, and EAI.
    • Data Management and Quality: data mapping, data profiling, data catalog, relational data modeling, master data management, data governance, metadata management (ex. Data.World).
    • Data Formats: csv, pipe-delimited, JSON, XML, Parquet.
    • Data Latency: nightly batch, intra-day batch, API calls, near real-time, messaging, streaming

    Applicable Certifications.

    • Core Certification (preferred)
    • Data Management Professionals (CDMP)
    • Fundamentals Certification

    Want to Join us? Apply here or send your resume to

    TECHNOLOGY. INNOVATION. PEOPLE

    The AE Advantage

    We're not a staffing company: We're an IT Solutions Integration company with an IT Staff Augmentation Division. We've been Madison-based for over 70 years. Not only is Madison the market we serve, but it's our home.

    ** We pay a generous bonus for the referral of an eligible candidate who works for AE Business Solutions for 90 days**

    AE Business Solutions does not sponsor applicants for employment visas.

    AE Business Solutions is an Equal Opportunity Employer. EOE/AA