Sr. Applications Analyst - SQL Administrator

Job Opportunities | Montgomery County (governmentjobs.com)

The City of Centerville is hiring an IT Director.

Here is a link to the position description: https://www.centervilleohio.gov/Home/Components/JobPosts/Job/173/1346

https://recruiting.paylocity.com/Recruiting/Jobs/Details/858373

Job Type

Full-time

Description

At Mile Two, we are always looking to strengthen our organization by adding the best available talent to our staff. We’re seeking a Talent Acquisition Specialist to help us source, identify, screen, and hire individuals for various roles in our company. 

Our ideal candidate will have excellent communication and organizational skills, 5-7 years experience in talent acquisition of technical roles with at least 2-3 years in DOD recruiting, proficiency in Applicant Tracking Systems, and the ability to devise sourcing strategies for potential applicants. This role requires a candidate with excellent interpersonal skills as you’ll often be asked to work closely with others across different departments.

Objectives of this Role

• Input into overall hiring strategy of the organization to ensure our teams consist of a diverse set of qualified individuals
• Ensure the staffing needs of the company are being met, with a long-term talent strategy in mind
• Devise and implement sourcing strategies to build pipelines of potential applicants, such as employer branding initiatives 
• Create and implement end-to-end candidate hiring processes to ensure a positive experience
• Form close relationships with hiring managers to ensure clear candidate/interviewer expectations

Daily and Monthly Responsibilities

• Coordinate with hiring managers to identify staffing needs in different areas and departments
• Determine selection criteria for candidates by liaising with managers and other members of staff
• Source applicants through online channels, such as LinkedIn and other professional networks
• Create job descriptions and interview questions that reflect the requirements for each position
• Identify and refine down the most suitable talent from available candidates
• Plan interview and selection procedures, including screening calls, assessments, and in-person interviews – if possible
• Assess candidates’ information, including C.Vs., portfolios and references
• Organize and attend job fairs and recruitment events to build a strong candidate pipeline
• Keep records of all materials used for recruitment, including interview notes and related paperwork, to share with key stakeholders

Skills and Qualifications

• Work experience in talent acquisition for technical roles and DOD environment experience
• Familiarity with social media, C.V. databases, and professional networks
• Experience with full-cycle recruiting, using various interview techniques and evaluation methods
• Knowledge of Applicant Tracking Systems
• Experience in using networks to proactively source candidates
• A keen understanding of the requirements for each role in the company
• Proficiency in documenting processes and keeping up with industry trends
• Excellent interpersonal and communication skills

Preferred Qualifications

• Bachelor's Degree in Human Resources Management, or similar
• 5-7 years of experience as a Talent Acquisition Specialist for technical roles, or similar
• 2-3 years of experience recruiting in a DOD environment

Apply at https://www.winsupplyinc.com/support-services-careers

Position Summary

Responsible for working with business users to define requirements, create conceptual and technical designs, develop prototypes and programs, define and execute unit and integration tests, resolve defects, execute an implementation plan, and provide second tier support.

Required Experience:

• 4+ years of related professional experience
• Experience with onshore/offshore development teams (Optional)
• Angular (preferably Angular2 with typescript and Angular CLI – we are currently on Angular6)
• Other JavaScript flavors (preferred)
• Github profiles are a plus
• Spring Boot (Mandatory)
• RESTful Web Services
• Experience in an Agile/Scrum environment
• Ionic 3
• Airwatch
• Bootstrap
• HTML
• Managing Certificates
• Mobile Devices
• Experience coding in responsive/adaptive design
• Experience with Java Design Patterns
• Experience with Development of Shared Modules in Angular2 or Higher
• Bachelor's degree in Computer Science or related field or equivalent of 8+ years related professional experience.

Roles and Responsibilities

• Work with development teams in an agile context as it relates to software development, including test driven development, automated unit testing and test fixtures, and pair programming.

• Create Web application front end as per design comps and information architecture.
• Develop the Web App UI using HTML, CSS/SCSS, BootStrap and Angular 9.1 (and above) etc.
• Integrate front-end application with the application business layer
• Constantly learn new technologies and skills via media, courses, or new applications
• Plan and estimate projects and reports hours to administration for billing
• Follow best practices and standards for accessibility and cross-browser compatibility
• Work in teams with project managers, UI/UX designers, Developers and Architects
• Follow established coding standards and group procedures individually and in teams
• Efficiently operate in a Linux shell environment
• Configure Jenkins to automate builds and deployments
• Perform DevOps functions such as CI/CD scripting, test automation, etc
• Perform Code Reviews and Integration Testing
• Engage in requirement specification process for new software functionality
• Ensure design consistency with our development standards and guidelines

Required Qualifications/Skills:

• Minimum of Bachelors or above in Computer Science or Computer Engineering or in related field of study.
• Software development experience including: OOPS, distributed programming, design patterns, RESTful service implementation, Service Oriented Architecture, Test-Driven Development, Acceptance Testing.

• Multi-tier application design and development.
• Multi-threaded design and development.
• Excellent problem solving and communication skills.

Physical Demands

The physical demands here are representative of those that must be met to successfully perform the essential job functions with or without reasonable accommodations:

• Sitting for extended periods of time
• Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and other computer components

Winsupply is an equal opportunity employer, so it encourages all qualified individuals to apply including minorities, veterans, women, and those with disabilities.

Apply at https://www.winsupplyinc.com/support-services-careers

Position Summary

The Business Intelligence (BI) Analyst’s role is to study business requirements and design and implement BI software and systems to resolve those requirements. This includes integrating databases, data warehouses, and data access tools with business processes to drive success.

Accountabilities/Responsibilities

1. Prioritize and select projects.
2. Partner with business to gather requirements and translate into BI solutions.
3. Design, test, deploy, and supporting BI solutions to business constituents both within and outside Winsupply.
4. Assist users with questions, problems, communications, and training
5. Discover and troubleshoot issues as they arise in the technical environment
6. Participates in project and production support environments
7. Assists in ad-hoc projects as assigned
8. Provide detailed status and problem updates and analyses to all constituents
9. Provide guidance to others within the department and across other IS groups

Competencies for Success

1. Communication
2. Team work
3. Analytical and Critical Thinking
4. Communication
5. Planning and Organizing

Qualifications/Experience

• Minimum Qualifications
• BA/BS in Information Technology, Information Systems or Mathematics
• 4+ years of relevant IT or IS experience and School
• 2+ years of database experience
• Experience with Power BI or equivalent visual analytic tools
• Experience with the concepts of modern relational database management systems.
• Strong TSQL experience to include stored procedures, functions, merge statements and analytical functions.
• Have an understanding of the difference between operational and decisional databases.
• Experience with Microsoft SQL Server including
  • SQL Server Management Studio (SSMS)
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Analysis Services (SSAS)
  • SQL Server Agent
  • SQL Server Developer Tools
• Understanding of the various information domains in a typical data warehouse environment
• Must be able to do basic tuning and optimization of data warehouse databases
• Understand the basics of indexing schemes, constraints and be comfortable studying query execution plans
• Must be able to extract and load data from multiple systems/applications into data warehouse and vice versa through SSIS and SQL Server Agent jobs built from TSQL scripts
• Must be able to ensure accuracy and integrity of the data in data warehouse that is loaded from multiple source systems.
• Must be able to cleanup data as required
• Must have a grasp of basic statistical analysis concepts
• Tabular or multi-dimensional modeling preferred

The performance of essential job functions for this position require both access to valuable assets and interaction with others under potentially stressful conditions. Therefore, individuals demonstrating a history of illegal substance abuse, theft or violence present a higher risk of loss and may be disqualified.

Physical Demands

The physical demands here are representative of those that must be met to successfully perform the essential job functions with or without reasonable accommodations:

• Sitting for extended periods of time
• Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and other computer components

Winsupply is an equal opportunity employer, so it encourages all qualified individuals to apply including minorities, veterans, women, and those with disabilities.

Apply at https://www.winsupplyinc.com/support-services-careers

Position Summary

The Database Developer needs a thorough understanding of relational database theory and practice, along with in-depth knowledge of data systems and database methodology, design and modeling. This individual must be analytical and adept at problem solving, strategically design and implement production databases, and provide support for specific applications. The Database Developer focuses on the logical aspects of the database and application data, responsible for defining standards and models, and for developing, implementing, and overseeing database policies and procedures to ensure the integrity of data. The Database Developer will also monitor and ensure system performance issues do not arise due to database related issues.

Accountabilities/Responsibilities

1. Implement appropriate level of best practices for constraints, referential integrity, and triggers
2. Document models for new database development and/or changes to existing ones through data flowcharting
3. Understand and evaluate business requirements and translate them in to specific database solutions
4. Provide leadership in establishing and documenting data standards
5. Lead / manage projects and others to accomplish defined goals
6. Analyze impact of various upgrades and take appropriate action to mitigate potential risk (ex: iSeries PTFs and release upgrades)
7. Use querying and performance monitoring tools, such as MB Software, Visual Explain and Systems Navigator , to analyze current and future SQL statements and database design
8. Evaluate and select database components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions

Competencies for Success

1. Analytical and Critical Thinking
2. Builds Customer Experience
3. Communication
4. Planning and Organizing
5. Presentation Skills

Qualifications/Experience

• Minimum Qualifications

• Greater than 2 years related professional experience
• Associate’s degree in Computer Science or related field
• Similar work experience, technical skills or relevant certification may be considered in place of bachelor's degree; must maintain awareness of changing technology

• Desired Qualifications

• Bachelor’s degree in Computer Science or related field
• Certification directly related to computer programming

The performance of essential job functions for this position require both access to valuable assets and interaction with others under potentially stressful conditions. Therefore, individuals demonstrating a history of illegal substance abuse, theft or violence present a higher risk of loss and may be disqualified.

Physical Demands

The physical demands here are representative of those that must be met to successfully perform the essential job functions with or without reasonable accommodations:

• Sitting for extended periods of time
• Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and other computer components

Winsupply is an equal opportunity employer, so it encourages all qualified individuals to apply including minorities, veterans, women, and those with disabilities.

Headquartered in Dayton, Ohio since 1910, Mikesell’s Snack Food Company manufactures and/or distributes snack foods such as potato chips, pretzels, puffcorn, popcorn, cheese curls and pork rinds in Ohio, Indiana, Kentucky and Central Illinois. We have our manufacturing plant in Dayton and distribution centers in Dayton, OH, Indianapolis, IN and Louisville, KY.

We are searching for an experienced Sr.  Systems Administrator/Business Analyst Manufacturing to drive digital and business transformation objectives with a focus on internal solutions and customer interactions within the manufacturing and business processes. The role focuses on JD Edwards/ERP technical abilities within BI, data model and complex report design, configuration, implementation and support, building and maintaining relationships with business stakeholders, understanding of metrics and KPIs, ability to work with cross-functional teams; complex project management and communication skills.

This position is an application and service-oriented role that provides a customer-focused IT function supporting JD Edwards/ERP operational efficiency, quality, process improvement, customer service and growth.  This vital role will develop and continuously align the multi Mikesell’s site manufacturing, e-commerce operations and our corporate office digital ecosystems with rapidly changing business needs and the Mikesell IT technical roadmaps. These roadmaps will support complex and exciting IT initiatives that require understanding of analytical problem-solving techniques, project management, lifecycle management and operational excellence.  Work in our innovative environment and embrace our core values of integrity, dedication, ownership, collaboration and respect. 

The Sr. Systems Administrator/Business Analyst Manufacturing Analyst is also responsible for a wide range of activities focused on the delivery of timely and accurate reports and automated, user-focused business processes: generating audit reports, troubleshooting and resolving data integrity issues, requirements gathering, determining business requirements, performing complex systems and data analysis, creating specifications, ensuring stability and integrity of software applications, planning, and testing software system configuration changes, developing project implementation and test plans, providing end-user application support, training users, and supporting information systems projects.

REQUIRED EXPERIENCE:

·        5 + years of experience in implementing and supporting ERP application including Manufacturing, Distribution, Supply Chain, Inventory Management, and Transportation

·        3-5 years of experience in JD Edwards/SAP/relative manufacturing platform - functionality and application process flows of supported modules (Manufacturing, Distribution, & Finance)

·        EDI experience preferred

·        Experience in collaborating with business partners, fellow systems analysts and other IT team members to understand requirements and develop solutions that are well architected, stable, reliable, and cost effective.

·        Knowledge of any third-party integration and process automation in systems like EDI, Salesforce.com, reporting tools (BI Publisher or Reports Now), DSI warehouse management

·        Must be able to work well in a dynamic, fast paced environment

·        Results Oriented - Possesses current industry & job knowledge; is organized & efficient; demonstrates effective time management & multi-tasking skills; makes decisions in a timely manner

·        High attention to detail, process oriented, strong analytic/problem solving skills and abilities to understand business and technology impact

·        Superior communication skills, oral and written; the ability to convey technically complex information and concepts in easily understood terms.

• ·        Strong proficiency in Microsoft Office 365 (Expert Excel and PowerPoint is a must). 

OTHER DUTIES:    Please note this job posting does not constitute a job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the incumbent for this job. Duties, responsibilities and activities may change at any time with or without notice.

Our team members are the key to our success and that is why we offer career opportunities with outstanding benefits including:

• Comprehensive Medical, Dental, Vision Coverage
• 401(k) Retirement Plan with Employer Matching
• Supplemental Voluntary Benefits (STD, Life, Accident)
• Generous PTO Policy & Paid holidays
• FSA -Flexible Spending Account

Job Level: Individual Contributor
Schedule: Full-time
Is remote work (i.e., working from home) allowed for this position? No but hybrid possibility
Does this position offer relocation?   No

Please send resume and compensation expectations to awagner@mikesells.com

E.O.E.

https://www.linkedin.com/jobs/view/2784783488/?recommendedFlavor=IN_NETWORK

https://www.linkedin.com/jobs/view/2805735421/?recommendedFlavor=IN_NETWORK

https://www.linkedin.com/jobs/view/2750139948/?recommendedFlavor=IN_NETWORK