Senior Data Engineer

2 days ago

Charles Town, United States APEI Full time
Description

Senior Data Engineer
American Public Education Incorporation

The Senior Data Engineer has the unique opportunity to help lead enterprise data solutions with Snowflake and Azure within American Public Education, Inc. (APEI). The successful candidate is responsible for analyzing data requirements, data models, and developing solutions for the Enterprise Data Warehouse, Data Marts, Operational Data Stores, and Enterprise Reporting and Analytic initiatives. She/he will have experience with data profiling/deduplication techniques, Master Data Management, Data Governance, with multiple back-end languages, scripting, API development, and custom plugins and tools.

The Sr. Data Engineer will closely with business and IT team members to develop, optimize, and maintain the data pipelines and supporting the build of the data ecosystem for delivering enterprise data for wide consumption including developing data models, corresponding data architecture documents and API's. She/he may be responsible for leading data engineering initiatives, partner with IT and other Business teams, and identify, define, analyze, and implement data solutions with high scalability, performance, and 24x7 availability.

Key Accountabilities:

  • Must have deep hands-on experience delivering and implementing data lake/warehouse, business intelligence, and data integration on-premises and Cloud-based technologies with RDBMS, ETL/ELT, and BI; such as MS SQL Server, SSIS, SSRS, MicroStrategy, Power BI; Snowflake and Azure experience required.
  • Analyzes data requirements and develops data models, ETL, and related solutions to support EDW, DM, ODS and Enterprise Reporting and Analytics initiatives.
  • Participates in database design discussions, collaborating with architects and reporting specialists to ensure the database designs are accurate and that they support efficient reporting.
  • Develops, validates, and maintains ETL architecture and designs for accuracy and performance, identifying opportunities for improvement.
  • Analyzes the impact of source system data design changes as they relate to existing ETL solutions and makes appropriate changes to existing ETL solutions.
  • Performs data analysis, profiling, understands source data, and designs ETL solutions to accommodate nuances, prevent data redundancy or integrity across systems.
  • Employs best practices and an enterprise-wide approach to data warehouse and ETL designs.
  • Assists with Master Data Management, preference given to Boomi Data Hub.
  • May lead data solutions development, design, and reviews.

Requirements:

  • Demonstrates competence, experience, knowledge, and understanding of data architecture and administration concepts, including dimensional modeling, ETL/ELT, views, and advanced SQL functions.
  • Solid data modeling experience and loading with transactional and dimensional systems.
  • Strong Snowflake, Azure, Microsoft SQL development experience writing complex SQL queries, scripts, stored procedures, and ETL/ELT processes.
  • Excellent data acquisition, profiling, transformation, and loading experience with standard and cloud-based tools, preferred with Microsoft SSIS and Power BI.
  • Well experienced with data and integration troubleshooting and problem-solving skills.
  • Extensive experience querying multiple data sources and platforms preferred, especially SQL Server.
  • Experience with Azure DevOps, Visual Studio, Python, Spark, and BI tools such as MicroStrategy, SSRS, and Power BI.
  • Experience with data modeling tools, Master Data Management, preferably Boomi MDM.
  • Experience with ERwin, ER/Studio or similar data modeling tools.
  • Experience developing/analyzing stored procedures and relational database programming.
  • Ability to be flexible and think strategically in a rapidly changing environment.
  • Ability to quickly digest information and understand the business objective.
  • Displays strong responsibility and attention to detail, collaboration, and problem-solving abilities with a positive attitude.
  • Excellent initiative, organization, and ability to work with limited supervision.
  • Minimum of 8+ years of experience in data analysis, data modeling, and developing integration solutions for the Enterprise Data Warehouse/Marts/Operational Data Stores and experience with Snowflake and Azure Data Lake.
  • Bachelors degree preferred

*Please note that you may be asked to provide your Web portfolio in addition to your application and resume.

About Us:

Online, on campus and in the workplace, we provide higher education and training to our country's heroes - military service members, veterans, nurses, government employees, and motivated professionals that want to make a difference. American Public Education, Inc. educates service-minded students, ranging from the military, public service, federal agencies, and nursing communities, through American Public University System (APUS), Hondros College of Nursing (HCON), Rasmussen University and Graduate School USA (GSUSA).

It is the policy of American Public Education, Inc. (APEI) to afford equal opportunity to all qualified persons. We treat all qualified individuals equally as to their recruitment, hiring, assignments, advancements, compensation, and all other terms and conditions of employment. American Public Education, Inc. does not discriminate on the basis of race, color, religion, creed, sex, age, national origin, sexual orientation, or physical, mental, or sensory disability, or any other characteristic protected by law.

Pay Transparency Statement

If you are a resident of a state with designated pay transparency requirements and this role is available remotely, you may be eligible to receive additional information about the compensation and benefits for this role, which we will provide upon request. Please send an email to recruiting@apei.com

  • Senior Software Engineer, Application Administrator

    4 weeks ago

    Charles Town, United States APEI Full time

    Description Sr. Software Engineer, Application Administrator, Salesforce American Public Education, Inc. The Senior Software Engineer, Application Administrator, Salesforce is responsible for the administration and support of the Salesforce environment at American Public Education, Inc. (APEI), ensuring availability, proper function, and access for the...

  • Senior Software Engineer, Application Administrator

    19 hours ago

    Charles Town, United States APEI Full time

    Description Sr. Software Engineer, Application Administrator, Salesforce American Public Education, Inc. The Senior Software Engineer, Application Administrator, Salesforce is responsible for the administration and support of the Salesforce environment at American Public Education, Inc. (APEI), ensuring availability, proper function, and access for the...

  • Senior Software Engineer, Application Administrator

    1 month ago

    Charles Town, United States APEI Full time

    Description Sr. Software Engineer, Application Administrator, Salesforce American Public Education, Inc. The Senior Software Engineer, Application Administrator, Salesforce is responsible for the administration and support of the Salesforce environment at American Public Education, Inc. (APEI), ensuring availability, proper function, and access for the...

  • Senior Polymers Engineer

    6 days ago

    Saint Charles, Missouri, United States Mapei Full time

    **Job Title:** Senior Polymers EngineerAbout Us: MAPEI is a world leader in manufacturing solutions for the building industry. With over 11,000 employees worldwide, we have 100 subsidiaries in 57 countries and 86 manufacturing plants in 35 nations.We are looking for a Senior Polymers Engineer to join our team. As a key member of our Operations Engineering...

  • Senior Clinical Review Specialist

    4 weeks ago

    Saint Charles, Illinois, United States Doctor's Data Inc Full time

    Job OverviewWe are seeking a highly skilled Senior Clinical Review Specialist to join our team at Doctor's Data, Inc. in the post-analytical review and release of test reports.This role is ideal for an individual who wants to be part of ensuring patient results are accurate and valid. The successful candidate will have excellent organizational and data...

  • Senior Chemistry Laboratory Specialist

    7 days ago

    Saint Charles, Illinois, United States Doctor's Data Inc Full time

    Doctor's Data Inc. is a premier international clinical laboratory specializing in integrative medicine with over 50 years of experience. We are seeking an experienced chemistry technologist to fill a role in our clinical laboratory as a senior chemist. This is a full-time position with competitive salary and benefits package.As a senior chemist, you will be...

  • Senior DMS and Risk Engineer

    1 week ago

    Town 'n' Country, Florida, United States Vaco Full time

    About the Role:We are looking for an experienced Senior DMS and Risk Engineer to join our team. In this position, you will be responsible for managing the ownership of configuration, deployment, management, and administration of DMS and Risk systems, as well as custom in-house applications/services. Strong technical leadership skills and a focus on...

  • Chemistry Laboratory Senior Technologist

    7 days ago

    Saint Charles, Illinois, United States Doctor's Data Inc Full time

    Job OverviewAt Doctor's Data Inc., we are seeking an experienced laboratory professional to join our clinical laboratory team as a senior chemistry technologist.This is a full-time split-shift position, working 11:00AM-7:30PM, and offers a comprehensive benefits package, including 401(k) with Employer Match, generous time off, and opportunities for challenge...

  • Senior Mechanical Engineer Position

    6 days ago

    Lake Charles, Louisiana, United States Polaris Engineering Full time

    Job OverviewPolaris Engineering seeks a skilled Senior Mechanical Engineer to join its team. This is an excellent opportunity for a motivated professional to utilize their technical expertise and passion for mechanical engineering to drive project success.Job DescriptionThis position plays a critical role in specifying and designing mechanical equipment for...

  • Senior Production Engineer

    4 months ago

    Lake Charles, United States Jane Roberts Consulting Full time

    Company is currently looking for a dynamic individual to work as a Senior Production Engineer at their Lake Charles, LA location. In this role, you will play a critical role in the success of the assigned area production units. The successful candidate will provide leadership and innovation to ensure that the units are run safely, efficiently and in...

  • Senior Production Engineer

    4 months ago

    lake charles, United States Jane Roberts Consulting Full time

    Company is currently looking for a dynamic individual to work as a Senior Production Engineer at their Lake Charles, LA location. In this role, you will play a critical role in the success of the assigned area production units. The successful candidate will provide leadership and innovation to ensure that the units are run safely, efficiently and in...

  • Senior Production Engineer

    4 months ago

    lake charles, United States Jane Roberts Consulting Full time

    Company is currently looking for a dynamic individual to work as a Senior Production Engineer at their Lake Charles, LA location. In this role, you will play a critical role in the success of the assigned area production units. The successful candidate will provide leadership and innovation to ensure that the units are run safely, efficiently and in...

  • Senior Engineering Cost Analyst

    1 week ago

    Lake Charles, Louisiana, United States Elevate Human Capital Full time

    We are seeking an experienced Senior Engineering Cost Analyst to join our team at Elevate Human Capital. In this role, you'll be responsible for analyzing and reporting on engineering costs, identifying areas for cost reduction, and developing cost-saving strategies.The ideal candidate will have a bachelor's degree in civil engineering or equivalent, along...

  • Senior Electrical Design Engineer

    1 month ago

    Town of McColl, United States Diverse Systems Group Full time

    Job OverviewWe are seeking a highly skilled Senior Electrical Design Engineer to join our dynamic team at Diverse Systems Group, LLC (DSG).About the RoleThis is an exciting opportunity for an experienced electrical engineer to contribute to impactful projects and advance their career in a supportive and innovative environment.Key ResponsibilitiesIdentify...

  • Senior CloudOps Engineer

    4 weeks ago

    Town of Hempstead, NY, United States Tyler Technologies, Inc. Full time

    The director is expected to manage and grow a portfolio of digital government services, including a robust content management platform, custom-developed applications, payment processing applications, and web applications. Windows Systems Administrator Overland Park, Kansas | Hartford, Connecticut | Augusta, Maine | Baton Rouge, Louisiana | Charleston, West...

  • Senior Production Engineer

    1 day ago

    Lake Charles, United States Indorama Ventures: Indovinya Full time

    Indorama Intermediate Chemicals is currently looking for a dynamic individual to work as a Senior/Principal Production Engineer at our Lake Charles, LA location. In this role, you will play a critical role in the success of the assigned area production units. The successful candidate will provide leadership and innovation to ensure that the units are run...

  • Senior Production Engineer

    22 hours ago

    Lake Charles, United States Indorama Ventures: Indovinya Full time

    Indorama Intermediate Chemicals is currently looking for a dynamic individual to work as a Senior/Principal Production Engineer at our Lake Charles, LA location. In this role, you will play a critical role in the success of the assigned area production units. The successful candidate will provide leadership and innovation to ensure that the units are run...

  • Senior Engineering Supervisor

    2 weeks ago

    Saint Charles, Missouri, United States Craftsmen Industries Full time

    We are seeking a highly skilled engineer to join our team as a Senior Project Engineer. In this role, you will be responsible for managing large projects from conceptual phase through 3D CAD modeling, fabrication drawings, and shop support.The successful candidate will have a strong background in mechanical engineering and project management, with experience...

  • Senior Project Engineer

    1 month ago

    St Charles, United States Craftsmen Industries Full time

    About Craftsmen Industries Craftsmen Industries custom manufactures unique specialty trailers and vehicles and large format printed elements for experiential marketing and industrial solutions for brands across the industry spectrum including Boeing, PepsiCo, and Anheuser-Busch. We pride ourselves on creating our products fully in-house from initial design...

  • Senior Project Engineer

    1 day ago

    St Charles, United States Craftsmen Industries Full time

    About Craftsmen Industries Craftsmen Industries custom manufactures unique specialty trailers and vehicles and large format printed elements for experiential marketing and industrial solutions for brands across the industry spectrum including Boeing, PepsiCo, and Anheuser-Busch. We pride ourselves on creating our products fully in-house from initial design...