Junior BI Analyst job – SGA – New Castle, DE

Responsibilities:

• Take ownership of our data and constantly improve its quality and integrity; proactively identify data quality issues at every step and coordinate with the appropriate teams and/or vendors to resolve any discrepancies.
• Design, build, manage, and own a growing and complex data pipeline.
• Determine the data owner of record to ensure consistent and uniform data integrity.
• Analyze system performance and outcomes to maintain and improve efficacy of analytic systems.
• Manage company data requests including API connections, mapping, importing and exporting of data to ensure consistent, correct and safe transfer of information.
• Combine multiple sources of data from APIs, RSS feeds, and human input into a single, structured data store while dealing with issues of duplication, cross-referencing, relational structure, and non-relational/denormalized storage.
• Coordinate data mapping and data translation activities, working to increase accuracy.
• Support department needs for reporting by understanding the needs of data, format, frequency, delivery and coordinating the request through the appropriate channels.
• Extract data from multiple sources, standardize the data, and produce analyses.
• Create and maintain SQL databases tables/indexes/triggers, stored procedures and scheduled jobs.
• Develop, test and debug SQL server queries, procedures and jobs related to database requirements for data services operations and ongoing projects.
• Create ongoing and ad-hoc reports with appropriate metadata and quality information.
• Support internal resources with new customer EDI, ACES and PIES requests.
• Document database structures and define data elements to enable re-use

Required Skills:

• BI Software Experience: Tableau, Domo or Qlikview
• Excellent SQL and data warehouse skills.
• Experience writing complex queries on large data sets.
• Proven experience with API integrations.
• Data Exchange and Reporting (SSIS, ETL, SSRS)
• Scripting Languages: T-SQL
• Experience writing SQL Stored Procedures & Triggers
• Experience with database table design, stored procedures and understanding system process flows
• Advanced Excel skills. ie Pivot Tables,V-Lookups and macros.
• BA/BS degree in quantitative field (Mathematics, Statistics, Engineering, Economics) required.

Preferred Skills:

SGA is a Certified Women’s Business Enterprise (WBE) celebrating over thirty years of service to our national client base for both permanent placement and consulting opportunities. For consulting positions, we offer a variety of benefit options including but not limited to health & dental insurance, paid vacation, timely payment via direct deposit. SGA accepts transfers of H1 sponsorship for most contracting roles. We are unable to sponsor for Right-to-Hire, Fulltime, or Government roles. All parties authorized to work in the US are encouraged to apply for all roles. Only those authorized to work for government entities will be considered for government roles. Please inquire about our referral program if you would like to submit a candidate for any of our open or future job opportunities. SGA is an EEO employer. We encourage Veterans to apply. To view all of our available job postings and/or to learn more about SGA please visit us online at www.sgainc.com.