ERP SQL Systems Programmer/Data Analyst – AX – Multiple Locations Direct Hire/ Full Time Employee
ALL DKKD JOBS: https://dkkdstaffing.com/job/dkkd-staffing-top-jobs-consolidated/
Please see the Application and Job-Related questions below.
Background/ Drug/ Vaccine Check Disclaimer: (each company is different)
- If selected, there might be a background check that includes a drug screen (usually 4-panel-excluding marijuana) and sometimes credit checks for financial clients.
- Most companies might also have a vaccine mandate, so once hired, we (or the client) will ask for proof of vaccination if required. If you are not vaccinated, we/they might ask you to work with them on a religious or medical exemption if necessary.
TITLE: ERP SQL Systems Programmer/ Data Analyst – AX
LOCATION: El Segundo or Thousand Oaks, CA
DURATION: Direct Hire
SUPERVISORY RESPONSIBILITIES:
- This job has no supervisory responsibilities but provides technical leadership to lower-level employees. This includes, but is not limited to training employees, planning, assigning, directing work and resolving technically related work problems. It also includes interaction with other technical teams (e.g., server team, client team, applications team, support team, etc.). Additionally, the position will assist the manager in managing vendor relationships.
SALARY: To be discussed
- NOT open to Corp to Corp.
- Those authorized to work in the US are encouraged to apply.
- DKKD Staffing does not sponsor and cannot support H1, EAD, TN, etc. No outside agencies please.
JOB OVERVIEW
The ERP SQL Programmer/Data Analyst is responsible for designing, planning, and implementing databases, including security, access, and documentation in client server enterprise applications. Provides technical assistance in identifying, evaluating, and developing systems and procedures as they relate to databases. Assignments may include database structure and layout, installing, upgrading, and managing database applications including data warehouses and business intelligence systems.
Essential Duties and Responsibilities include the following. Other duties may be assigned.
- Design and maintenance of databases and data warehouses solutions using Microsoft technologies that include SQL, SSRS, SSIS, and SSAS (both OLAP and Tabular models)
- Development and maintenance of complex optimized queries, views, functions, and stored procedures using T-SQL
- Database development using RDBMS standard practices and principles including star schemas, ERD’s, primary/surrogate keys, and indexes
- Conducts analysis, design, evaluation, modification, testing and implementation of enterprise-wide systems (e.g., Infor XA, Dynamics AX, IFS, Baan, Costpoint) across functional areas
- Responsible for software integration, external interface development and technical documentation
- Plans and directs the evaluation of potential third-party applications and prepares design proposals to reflect cost, time and alternative actions to satisfy existing and future needs of the Corporation
- Supports BI and Document Management applications integrated to ERP systems and SQL databases (Power BI, Targit, Tab Fusion or similar experience)
- Develops test plans and protocols for evaluation of system performance
- Conducts analysis of systems specifications and uses the latest analysis/diagramming tools to represent business/technical processes
- Develops conversion and system implementation plans
- Prepares and obtains approval of system and programming documentation
- Recommends changes in development, maintenance and system standards
- Coordinates system upgrade activity
- Trains user personnel in the conversion and implementation of the system
- General Support – The position will have support responsibilities specific to the supported applications. Support will require troubleshooting and problem resolution related to user and connectivity issues.
- Responds to emergencies as needed
- Daily availability to include evenings and weekends when necessary to reach goals and deadlines.
Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Other Knowledge, Skills, and Abilities:
- Strong interpersonal skills:
- Strong oral and written communication abilities with all levels of management, employees, and customers, ability to communicate and explain information efficiently:
- Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals:
- Ability to develop solutions to problems of unusual complexity which require a high degree of ingenuity, creativity, and innovativeness. Challenges are frequently unique and solutions may serve as precedent for future decisions:
- Follows all import/export requirements, consulting with facility import/export personnel as required:
- Basic Knowledge of ISO and/or AS9100:
- Working knowledge of Lean Manufacturing/6 Sigma/Kaizen:
- Knowledge of specific software (design, analysis, ERP…):
Action: Please complete the Application & Job-related questions below. For fastest response, please answers to Di@DKKDstaffing.com
APPLICATION QUESTIONS (Please answer all questions)
- Name:
- Best Contact Info:
- Your Linked In:
- Where do you live and your desired geographical location:
- Why looking for a new job:
- Availability for interviews and a new job:
- Willing to work 100% on-site or hybrid:
- Are you open to relocation if required:
- Do you have an active passport if needed for the job:
- Are you open to travel if needed:
- Are you authorized to work in the US (Please indicate US, Green Card, or Other):
-
- If not US Citizen or GC, do you require sponsorship at any time, or will you in the future?
- Salary Expectations: (We need a range) $
- Sizes of staff overseen and their titles: (include # of direct reports)
- Budgetary Responsibility: $
- Education/Certs/Degrees: (also indicate which certs are active – Bachelor’s degree (B.S.) from four-year college or university in a related fields and 3-5 years of directly related experience and/or training; or equivalent combination of education and experience required)
- Who Referred You/ How Did You Hear About Job/ DKKD Staffing:
JOB-RELATED SCREENING QUESTIONS/ JOB REQUIREMENTS:
NOTE: Please provide your # of years of experience (per bullet/colon) and last year used. Elaborate if needed. If no experience, please indicate NA or none.
- Experience and/or the title of ERP SQL Systems Programmer/ Data Analyst – AX:
- Basic Knowledge of ISO and/or AS9100:
- Working knowledge of Lean Manufacturing/6 Sigma/Kaizen:
- Knowledge of specific software (design, analysis, ERP…):
Computer Skills:
- Advanced knowledge and in-depth experience with the following applicable system:
-
- Microsoft SQL Stack:
-
-
- MS SQL Server with strong T-SQL experience:
- SSRS/SSIS/SSAS:
- Database design and performance optimization:
- Complex queries, views, functions, and stored procedures:
-
-
- Dynamics AX:
-
-
- Programming methodologies, structures, and concepts – .Net framework, UML, XML, SharePoint, BizTalk:
- Object oriented development languages (e.g., X++, C++, C#, VB.NET, Java, .NET framework):
- AIF (Application Integration Framework), BOF (Business Operation Framework), TFS (Team Foundation Sever) and SSRS (SQL Server Reporting Services):
- Dynamics AX Trace Parser:
- Diagnosis of X++ code tracing with performance analysis outcomes and recommendations:
- Database design and SQL (Query Language):
- Experience integrating ISV solutions:
- Functional application knowledge:
-
-
- IFS:
-
-
- Familiar with ERP software/IFS applications in general:
- Applicable business process, SDLC:
- IFS Programming methodologies, structures, and concepts – .Net framework, UML, XML, BizTalk:
- Object Oriented Design principles:
- Relational database, Oracle Database:
- IFS Foundation1 Administration such as Users, Security, Profile, Custom Objects, and Events:
- Quick Report, IFS Development Studio, IFS Report Designer Development and SSRS:
- Strong SQL and PL/SQL languages:
- Strong Crystal Report:
-
- Microsoft Office Suite (i.e., Outlook, Word, Access, Excel, PowerPoint, Project, Visio, etc.):
- Support ticketing systems, change control methodologies and their importance to ITIL best practices:
- IT security concepts and best practices (e.g., Microsoft, Cisco, etc.):
Connect with us on Linked In: www.LinkedIn.com/in/DianeKrehbiel
ALL DKKD JOBS: www.DKKDstaffing.com
We get 100’s of applicants applying to us. Please see the instructions above on how to apply to help us.
Diane “Di” Krehbiel-Delson
Executive and Technology Recruiting
Westlake Village, Ca 91362
JOBS & Application: www.DKKDstaffing.com
References: www.LinkedIn.com/in/DianeKrehbiel
Leadership JOB LEADS on LINKED IN GROUP: Diane Krehbiel Executive & Technology Recruiting
IND123