Published date Posted on Indeed on Jan 11, 2022 (12 d ago)

Responsibilities

The Data Analyst will work with the stakeholders to discover organizational data needs and develop solutions to support data-driven decision-making. They will identify data sources and criteria needed, develop complex SQL, document specs for ETL and BI developers, test the output, and ensure user acceptance. The Data Analyst will proactively identify data gaps and introduce improvements. This will include obtaining data from new sources and designing new data flows and transformation sequences in collaboration with ETL developers and data architects. Most activities will involve heavy use of complex SQL.

  • Develop data solutions to support business needs and data-driven decisions
  • Work with stakeholders to understand their data needs and turn vague one-liner requests into actionable, testable requirements
  • Analyze complex data that requires consideration of multiple factors to interpret the information
  • Collaborate with process owners to understand data definitions appropriate to each use case
  • Document data definitions, derivations, flows, and dependencies between source systems
  • Use SQL to explore, extract, and analyze data, including historical data
  • Define data sources and criteria needed to support reporting and data integrations
  • Assess data quality and completeness
  • Identify causes of data discrepancies and develop solutions to address them
  • Propose solutions to collect or derive new data points to support metrics and identify trends
  • Propose data structure, transformation, and flow for new data sources
  • Develop complex SQL to derive and transform data from multiple sources
  • Write requirements and technical specs for reports, analytics, and dashboards
  • Serve as a resource to Business Analysts and Developers for data-related needs

Education and Experience (required)

  • Bachelor's degree in Computer Science, Statistics, Business, Finance, or related field
  • 5-7 years performing data analysis
  • 4-5 years of experience writing complex SQL queries
  • 3-4 years of experience working directly with stakeholders on requirements

Qualifications (required)

  • Above average analytical and conceptual thinking; resourceful problem-solving
  • Fascination with data, desire to learn new concepts
  • Expert level SQL skills; experience writing complex queries with multiple table joins, subqueries, and historical data
  • Basic knowledge of database design principles, deep understanding of relational databases
  • Familiarity with data warehouse, data mart, ETL, and Web services concepts
  • Attention to detail in verbal and written interactions; strong listening skills
  • Experience communicating with all levels in the organization in a clear and concise manner using non-technical language
  • Ability to lead others to articulate requirements and uncover hidden needs
  • Excellent documentation skills
  • Flexibility with changing requests and priorities

Additional Qualifications (preferred)

  • Experience with PeopleSoft HCM data
  • Familiarity with statistical methods
  • Predictive analytics/forecasting experience

Job Types: Full-time, Contract, Temporary

Pay: $53.75 per hour

Schedule:

  • 8 hour shift
  • Day shift
  • Monday to Friday

Application Question(s):

  • Can you work under a W2 or 1099?
  • What is your desired contract hourly rate?

Experience:

  • writing complex SQL queries: 4 years (Preferred)
  • data warehouse, data mart, ETL, and Web services concepts: 4 years (Preferred)

Work Location: Remote


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

There can be a lot of pressure that comes with a new year. New workout routine, new goals, and if you’re here reading this, perhaps a new job. Oh, and apparently a new variant. Take a second away from your gym selfie-filled Instagram feed and hear us out: Being in the beaut

General Dynamics Information Technology General Dynamics Information... |
|
2 d ago

Travel Required: NonePublic Trust: BI Full 6C (T4)Requisition Type: RegularGDIT, a Federal marketplace leader in next-generation IT solutions and services, is seeking highly qualified and motivated IT professionals like you who are eager to contribute to our critical Homeland Sec

Nelnet is a student loan servicer that's grown into a fiber internet pioneer, real estate investor, and software provider. But that's just the beginning. With 6,500 associates and growing, we take our business wherever superior customer experiences and ingenuity are needed.The pe

Aspect Software Aspect Software |
|
3 d ago

Alvaria employs a team of passionate individuals who are changing the face of customer engagement. Over our 40-year history we have empowered employees by creating an inspired community that values Urgency, Accountability and Results. Our ability to think big has enabled us to co

Piper Companies Piper Companies |
|
5 d ago

Piper Companies is seeking a Manager of Data Engineering for a growing technology driven organization. The Manager of Data Engineering role is a 100% remote role that can reside anywhere in the United States. The Manager of Data Engineering will be working with a team primarily b

Professional Management Enterprises Professional Management Enterprises... |
Yesterday

Description:Summary: Asset Database Analyst will be responsible for accurate and timely report generation and asset tracking. Specific duties will include facilitating the processing of incoming tickets for ITAM support, maintaining the asset tracking databases for warehouse; ass

eCIFM Solutions eCIFM Solutions |
2 d ago

Title: Oracle DBA ConsultantHours flexible: 20-24 hours a monthLocation: RemoteWe are looking for a seasoned Oracle Database Administrator to support Internal and Client production databases. The Oracle DBA will demonstrate an elevated commitment to customer service, will possess

Axim Geospatial Axim Geospatial |
2 d ago

Overview:Axim Geospatial’s (Axim) mission is to use our expertise to provide clarity and solutions to help our customers solve the world’s national security, infrastructure, and environmental problems. We are the largest singular provider of end-to-end geospatial serv

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
5 d ago

As the Database Administrator, you will bring your SQL Server experience providing day-to-day support to the IT team creating the next generation of cloud and mobile-based logistics applications. This is a unique opportunity for an individual seeking new challenges and broad data

**NO 3rd PARTY APPLICATIONS-DIRECT SUBMISSIONS ONLY**Job Title: Senior Database AdministratorNo Sponsorship-U.S. Citizen or Full Green Card Holder Only (No 3rd Party Submissions)Status: Full-Time Employment, Contract (1099), Contract (1099) to HireLocation: Remote/Occasionally On

More jobs by this company

Resource Management Associates LLC. Resource Management Associates... |
10 d ago

Job responsibilities include but not limited to the following: *Installation of the database software product, applying new releases/patches, configuration, performing backup and recovery, monitoring databases performance and reorganizing database structures as needed.*Creation a