Full Time Job: BI Architect - Hilliard, OH, United States - Mill Run

    Mill Run
    Mill Run Hilliard, OH, United States

    1 month ago

    Default job background
    Full time
    Description

    For more than 50 years ADS has been manufacturing a variety of innovative and environmentally friendly alternatives to traditional materials.

    Headquartered in Hilliard, Ohio, we are a multi-billion dollar stormwater management company, manufacturing pipe and ancillary products.

    When it storms, we capture rain with our drain basins, convey it with pipe, store it using chambers and finally treat it with our water quality products, before safely returning water back to the environment.

    Our products help prevent flooding, which increases quality of life for people living in large cities, suburbs, and rural towns.

    We also believe in creating a circular economy and are the largest plastic recycling company in North America.

    We use plastic shampoo and detergent bottles to create pipe, diverting over 500 million pounds of plastic from landfills every year.

    ADS operates a global network of over 60 manufacturing plants and 30 distribution centers.
    We have amazing stories to tell, and we need your help getting our story out there. To learn more about ADS, please visit our website at (

    As an Analytics Architect, you will play a crucial role in designing, developing, and implementing data solutions that enable our organization to make informed decisions.

    You will be responsible for analyzing complex data requirements, architecting scalable data models, and collaborating with cross-functional teams to ensure the successful delivery of data-driven solutions.

    Design and implement architectures, models, integration processes, and pipelines.

    • Identify, collect, and consolidate data from various sources to enable effective data management and analytics.
    • Collaborate with IT and business stakeholders to understand data needs and deliver high-quality solutions.
    • Stay abreast of industry trends and advancements in data technology.
    Proven experience as a BI Architect, Data Architect, Data Engineer, or similar role.

    • Strong understanding of database structure principles and data modeling.
    • Experience with data visualization tools (Power BI/Tableau) and techniques.
    • Proficiency in SQL and familiarity with programming languages (e.g., Python).
    • Experience with Azure cloud services (e.g., Data Lake, Data Factory, Databricks, Synapse Workspaces).
    • Experience with Snowflake, Informatica.
    • Experience in BI/Analytics platforms implementations/transformations.
    • Familiarity with Power BI and/or Tableau for data visualization.
    • Knowledge of DevOps practices and CI/CD processes.
    Bachelor's degree in Computer Science, Engineering, or a related field.
    *