SQL Data Analyst

Stream Gas Dallas , TX 75201

Posted 2 months ago

Overview

The SQL Data Analyst reports to the Vice President of Planning and Risk and is responsible for developing data queries and analyses to facilitate decision making to ensure the success of business objectives and to provide solutions for departmental reporting needs.

As a SQL Data Analyst, the expectation is that you will provide technical leadership in the management of complex data, including developing, executing and automating reports for efficient and timely dissemination of critical information. You will work with various departments and sources to gather data, perform analysis and execute objectives

Responsibilities

  • Execute and enhance recurring business performance reporting packages and data analyses;

  • Create SQL queries to facilitate extraction of data into reporting tools, such as Power BI;

  • Analyze existing complex systems to understand and document data elements, relationships, data flow, dependencies and their related interfaces;

  • Actively participate in cross-functional teams providing analysis expertise, offering original perspectives and challenging the conventional views;

  • Perform other duties and assignments, as requested

Qualifications

  • Bachelor's degree in Business Information Systems or equivalent related experience;

  • Proven record of data management skills and experience with SQL;

  • Advanced Microsoft Office knowledge and application skills;

  • Ability to handle multiple assignments on a timely basis with a high degree of accuracy and attentiveness to details;

  • Enthusiastic team player with a committed work ethic and strong problem-solving aptitude;

  • High level of motivation and can-do attitude in a high-performance environment;

  • Exceptional personal and professional integrity and trustworthiness

  • Knowledge of network marketing business operations strongly preferred

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Analyst / Engineer SQL C
New!

Atrilogy

Posted Today

VIEW JOBS 11/17/2018 12:00:00 AM 2019-02-15T00:00 Our direct client is looking to hire a Data Analyst/Engineer for a 6+ Months contract role in Dallas, TX.<br /> Kindly go through the following JD and let me know if you are interested and available for a quick chat to discuss this opportunity in detail:<br /> <br /> <strong>Role: Data Analyst/Engineer<br /> Location: Dallas, TX (Only Local Candidates)<br /> Duration: 6+ Months<br /> <br /> NOTE: In-Person Interview is Manatory<br /> <br /> <u>Requirement:</u></strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Bachelor's degree </li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">At least 4+years of experience with ETL and advanced SQL skills - Adept at queries, report writing and presenting findings</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Expertise in Data Analysis, Data Profiling and SQL Tuning</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Expertise in translating business requirements to project design, development, and execution</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">C++/GoLang experience a must.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Ability to clearly communicate capabilities, opportunities, and recommendations to both technical and nontechnical audiences</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience working in Data warehouse ETL & BI platforms and have a good understanding of related development activities and challenges</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Strong knowledge of and experience with reporting, databases (SQL etc), programming ( ETL frameworks)</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience in understanding the source data from various platforms and mapping them into Entity relationship model(ER) for data integration and reporting.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Has deep understanding of data architecture & data modeling best practices and guidelines for different data and analytic platforms </li> </ul> <strong>Responsibilities:</strong>  <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Interpret and analyze data from various source systems to support data integration and data reporting needs within CBRE.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Identify, analyze, and interpret trends or patterns in complex data sets</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Work with team leads to prioritize business and information needs</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Prepare high-level ETL mapping specifications.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Develop complex code data scripts (Primarily SQL) for ETL</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Data Quality Control, Metrics</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Troubleshoot & determine best resolution for data issues and anomalies</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Manage exploratory data analysis to support database and dashboard development, as well as advanced analytics efforts</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">May assist in development of software technical documentation. </li> </ul> <strong>For immediate consideration please submit your resume in Word format, along with daytime contact information.  LOCAL CANDIDATES ONLY PLEASE unless you are willing to relocate yourself at your own expense.  <em><u>Client is unable to provide H-1B Visa sponsorship at this time.</u></em></strong><strong>  All submittals will be treated confidentially.  Selected candidate will be asked to pass a comprehensive background and drug screening.  </strong><strong><em>Principals only, no third parties please.</em></strong> <hr align="center" noshade="noshade" size="2" width="100%" />Established in 2000, Atrilogy Solutions Group, Inc. provides organizations of all sizes with high-quality, cost effective information technology (IT) and business process consulting & staffing services.  Our industry-leading service model combines experienced project managers with seasoned technical and functional consultants to eliminate client uncertainty and deliver superior value and results.<br /> <br /> Clients turn to Atrilogy for expertise in: <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">IT staffing and placement (Project Managers, Agile/Scrum Masters, Business Analysts, DBA’s, Software Engineers, Mobile Developers (iOS, Android), DevOps, Automation, QA, Systems & Network Engineers, Cyber Security / Information Security Specialists)</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">All major ERP & CRM packages (including Oracle, Workday, PeopleSoft, JD Edwards, Lawson, SAP, Dynamics AX, Salesforce, Microsoft CRM, NetSuite)</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Business Intelligence, Data Warehousing, and Big Data Integration</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Creative (Interactive Project Manager/Art Director, Information Architect, UI/UX Designer, Web/Graphic Design)</li> </ul> Atrilogy has been recognized by <em>Inc.</em> magazine as one of the nation’s fastest-growing, privately-held companies. Headquartered in Irvine, California, Atrilogy also has offices in Denver, Phoenix, Atlanta, and Dallas with satellite offices in Boston, Jersey City, Las Vegas, Seattle, and Delhi, India.<br />  <br /> Atrilogy Solutions Group is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, protected veteran status, or any other basis protected by applicable law, and will not be discriminated against on the basis of disability.<br />  <br /> In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form  Atrilogy Dallas TX

SQL Data Analyst

Stream Gas