Junior data analyst Jobs in Omaha, NE

Job DescriptionPosition SummaryApex Systems is seeking a Business Data Analyst with a strong background in data modeling and data profiling. Essential Job Functions

• Collaborate with cross-functional teams in different data domains to understand business requirements and provide data-driven recommendations and solutions.
• Design & develop data models, data catalogs & data dictionaries as part of data governance framework.
• Ensure all documentation are complete in regard to the requirements, with the need to seek approval before commencing any work.
• Manage data quality & integrity, including identifying and resolving data anomalies and inconsistencies in a timely manner.
• Apply several data profiling techniques to document and validate the structure, quality, and compliance of source data.
• Define reconciliation process between data cloud and source systems to ensure data integrity.Knowledge, Skills and Abilities
• Advanced knowledge of SQL languages, predominately TSQL and PL / SQL.
• Extensive understanding of relational databases, data warehouse architecture & principles, CDC techniques and dimensional modeling.
• Advanced knowledge of information engineering concepts, including business area analysis, business system design, data modeling, data governance and data security.
• Strong data profiling skills to analyze source system information.
• Good understanding of cloud data infrastructure including but not limited to Azure Data factory, Azure Synapse, Microsoft Fabric, Power BI,
• Good understanding of big data technologies such as Apache Spark to process & handle large datasets.
• Good understanding of Data Lake, Serverless Architecture & Delta Lake to implement delta Lakehouse architecture.
• Good understanding of extracting data through REST; Working knowledge of processing and storing complex data structures ingested through REST.
• Overall understanding of Power BI & Semantic Models.EEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.